Labels:text | screenshot | font OCR: Transaction Fact Table Product Product key Store dimension Store_key dimension Customer_key Customer. dimension Sales ticket key Sales ticket dimension Time key Time Quantity sold dimension Dollars sold Figure 1. A typical star join schema for a set of retail sales trans- actions. Each fact table record is a line item on a particular customer ticket. In this article, I show how to add a sixth "causal" dimension that explains why the sale took place.
